一意競合の要素

一意競合は、同じキー列を持つ行が最近挿入されたため、挿入のレプリケートが正常に実行されなかった場合に発生します。一意競合の競合レポートに書き込まれる情報については、「一意競合のレポート」を参照してください。

例9.1に、例8.3の値を使用して、一意競合のXML要素の書式を示します。

例9.1

<repconflict>

    <header>

      <time>

          <hour>13</hour>

          <min>36</min>

          <sec>00</sec>

          <year>2002</year>
          <month>03</month>

          <day>25</day>

      </time>

      <datastore>/tmp/masterds</datastore>

      <transmitter>SUBSCRIBERDS</transmitter>

      <table>

          <tableowner>REPL</tableowner>

          <tablename>TAB</tablename>

      </table>

    </header>

    <conflict type="insert">

      <conflictingtimestamp>3C9F983D00031128</conflictingtimestamp>

      <existingtimestamp>3C9F983E000251C0</existingtimestamp>

      <existingtuple>

          <column pos="1">

            <columnname>COL1</columnname>

            <columntype>NUMBER(38)</columntype>

            <columnvalue>2</columnvalue>

          </column>

          <column pos="2">

             <columnname>COL2</columnname>

             <columntype>NUMBER(38)</columntype>

             <columnvalue>2</columnvalue>

          </column>

             <columnname>TSTAMP</columnname>

             <columntype>BINARY(8)</columntype>

             <columnvalue>3C9F983E000251C0</columnvalue>

          </column>

       </existingtuple>

       <conflictingtuple>

          <column pos="1">

             <columnname>COL1</columnname>

             <columntype>NUMBER(38)</columntype>

             <columnvalue>2</columnvalue>

          </column>

          <column pos="2">

             <columnname>COL2</columnname>

             <columntype>NUMBER(38)</columntype>

             <columnvalue>100</columnvalue>

          </column>

          <column pos="3">

            <columname>TSTAMP</columnname>

            <columntype>BINARY(8)</columntype>

            <columnvalue>3C9F983D00031128</columnvalue>

          </column>

       </conflictingtuple>

       <keyinfo>

          <column pos="1">

            <columnname>COL1</columnname>

            <columntype>NUMBER(38)</columntype>

            <columnvalue>2</columnvalue>

          </column>

       </keyinfo>

    </conflict>

    <scope>TRANSACTION</scope>

    <failedtransaction>

       <insert>

          <sql>Insert into table REPL.TAB </sql>

          <column pos="1">

             <columnname>COL1</columnname>

             <columntype>NUMBER(38)</columntype>

             <columnvalue>2</columnvalue>

          </column>

          <column pos="2">

             <columnname>COL2</columnname>

             <columntype>NUMBER(38)</columntype>

             <columnvalue>100</columnvalue>

          </column>

          <column pos="3">

             <columnname>TSTAMP</columnname>

             <columntype>NUMBER(38)</columntype>

             <columnvalue>3C9F983D00031128</columnvalue>

          </column>

       </insert>

    </failedtransaction>

</repconflict>

---

前へ 次へ

Copyright © 2007, Oracle. All rights reserved.

目次 索引